Error: Cannot copy noncontiguous areas due to selection not linear and ...
Error:
Cannot do that command on a multiple selection.
Cause:
This problem occurs because the selected cells are not aligned either vertically or horizontally and do not have the same number of rows and/or columns.
Solution:
This behavior is by design of Microsoft Excel. In general, when copying noncontiguous cells, make sure the selected cells are aligned either horizontally or vertically and have the same number of rows and/or columns.